Welcome Guest, you are in: <root>BPHC UDS PLSCAREWare 5CAREWare 6Healthy Start • Login

Page History: CW Admin Utility

Compare Page Revisions

8 7 6 5 4 3 2 1 0 Current 8 7 6 5 4 3 2 1 0

« Older Revision - Back to Page History - Newer Revision »

Page Revision: Fri, 30 Mar 2018 09:40

The CW Admin Utility is the interface for the business tier settings. The CW Admin Utility is where Administrators can set the connection between the business tier and database, test the connection, adjust HL7 Interface settings, read diagnostics files, and set many other CAREWare options.


The default location for the CW Admin Utility is C:\Program Files\CAREWare Business Tier.



To run the CW Admin utility:

1. Go to C:\Program Files\CAREWare Business Tier.
2. Right click CW Admin.
3. Click Run as Administrator.
   

Note: The CW Admin Utility must always be run as administrator, even if the user is logged into a Windows Administrative account. If the CW Admin Utility is run without choosing Run as Administrator, the following error will occur when the RW CAREWare Business Tier service is stopped.




Server Settings shows the current settings set for the business tier, allows for editing of several business tier settings, and provides access to start and stop the business tier service.


To start or stop the business tier service: Click Start Server or Stop Server.


To edit a setting:

1. Select a Table Name.
2. Click Stop Server.
3. Click the setting Tag.
4. Click Edit.
5. Edit the value for Setting:.
6. Click Save.
   

To add a setting:

1. Select a Table Name.
2. Click Stop Server.
3. Click Add.
4. Enter a value for Tag:.
5. Edit the value for Setting:.
6. Click Save.
   

To delete a setting:

1. Select a Table Name.
2. Click Stop Server.
3. Click Delete.
   

Once changes are complete for settings, start the service by clicking Start Server.


The Services tab is another way to start and stop the business tier service. It includes an option to start and stop the database instance as well.



The diagnostics tab provides a view of diagnostics files created by running the business tier diagnostics in the client tier application. Click here to review instructions for running the diagnostics application.



The Database Info tab is used to test the connection between the database and the business tier. The Database Info tab shows database users, roles, and databases in the SQL Server Database Instance. The Database Info tab includes an option for adjusting the Database Compatibility Level. If there is an error in roles for the cwbt login, a Resolve button will appear to resolve the issue.



To access the Database Info tab, the SA password will have to be entered for the database instance. Here are instructions for setting the SA password.

• Auto Close – When the last user exits the database, the database is shut down cleanly and resources are freed (Recommended to remain off as this may degrade performance).
  
• Auto Shrink – If this setting is set to ON, SQL Server removes unused space from the database on a periodic basis (Recommended to remain off as this may degrade performance).
  
• View Index Suggestions – Produces queries than can improve indexes in CAREWare to improve performance.
  
  

View Index Suggestions includes the option to execute all of the suggestions or save the script so a DBA can review the queries and run the chosen queries using SQL Server Management Studio.



The Common Storage Settings tab is a link to the Common Storage Settings table in the database. It contains many settings for CAREWare, including HL7 Interface settings, the version of the database, an option to reset and unlock users, the database connection string for attachments. Here is a list of the Common Storage Settings in Excel.



Connection String Management allows users to set the business tier to database connection, encrypt the settings, and test the connection.

• Server Address – The name of the PC/Server where the CAREWare database instance is installed and the name of the CAREWare database instance.
• Database Name – The name of the CAREWare database in the SQL database instance.
• SQL login ID – The SQL login that is the database owner for cw_data.
• Password – The password for the SQL login ID.
• Show – Displays the hidden password for the login.
• Encrypt In Settings File – When checked the database connection string is encrypted in the BusinessTierSettings.xml file.
• Test Connection – Tests the connection between the CAREWare business tier and the CAREWare database.
• Save – Saves changes to the database connection string.
  

To download these instructions click here.

For additional instructions for the Connection String Management click here.

For instructions for the CW Admin Utility for CAREWare 5 build 945 or earlier click here.

Back to CAREWare 6 and CAREWare 5 Program Administrator FAQ